class CreateMwCatalogDataTypes < ActiveRecord::Migration
  def change
    create_table :mw_catalog_data_types do |t|
      t.column :mime_type, :string, :limit => 100
    end
    execute "INSERT INTO mw_catalog_data_types (mime_type) VALUES('text/plain');"
    execute "INSERT INTO mw_catalog_data_types (mime_type) VALUES('image/gif');"
    execute "INSERT INTO mw_catalog_data_types (mime_type) VALUES('image/jpeg');"
    execute "INSERT INTO mw_catalog_data_types (mime_type) VALUES('image/pjpeg');"
    execute "INSERT INTO mw_catalog_data_types (mime_type) VALUES('image/png');"
    execute "INSERT INTO mw_catalog_data_types (mime_type) VALUES('image/svg+xml');"
    execute "INSERT INTO mw_catalog_data_types (mime_type) VALUES('image/tiff');"
    execute "INSERT INTO mw_catalog_data_types (mime_type) VALUES('image/vnd.microsoft.icon');"
    execute "INSERT INTO mw_catalog_data_types (mime_type) VALUES('video/mpeg');"
    execute "INSERT INTO mw_catalog_data_types (mime_type) VALUES('video/mp4');"
    execute "INSERT INTO mw_catalog_data_types (mime_type) VALUES('video/ogg');"
    execute "INSERT INTO mw_catalog_data_types (mime_type) VALUES('video/quicktime');"
    execute "INSERT INTO mw_catalog_data_types (mime_type) VALUES('video/webm');"
    execute "INSERT INTO mw_catalog_data_types (mime_type) VALUES('video/x-matroska');"
    execute "INSERT INTO mw_catalog_data_types (mime_type) VALUES('video/x-ms-wmv');"
    execute "INSERT INTO mw_catalog_data_types (mime_type) VALUES('video/flv');"
  end
end
